import time

time_str = time.strftime("%Y-%m-%d 00:00:00.000", time.localtime())
# time_str = '2020-12-25 00:00:00.000'

sqlcmd_NewComerToday = '''
SELECT cWorkNo,cName,cPrimaryDept,cDeptName,cPosition FROM LS_DB1_hriteroa.hr.dbo.Employee WHERE rEnterDate='{}' 
'''.format(time_str)

sqlcmd_queryapi = '''
    SELECT OA_DEPTNAME,OA_POSITION,API_LEADERID,OA_ROLES FROM dbo.oa_autoops WHERE ID='{}'
'''